using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VABPR
    {
        public void SetUpNewRow(ref DataRow dwReturn, DataRow dwInput)
        {
            #region
            #endregion
            switch (app.company)
            {
                default:
                case "YGR":
                    #region===="YGR"======
                    dwReturn["ARMANDANT"] = "00";
                    dwReturn["ARAUFKRS"] = "ZT";
                    dwReturn["ARAUFLFD"] = "000004";
                    dwReturn["ARAUFPOS"] = "001";
                    dwReturn["ARAFOLGE"] = "000";
                    dwReturn["ARKZSPR"] = "N";
                    dwReturn["ARPNRKR"] = "  ";
                    dwReturn["ARPLFDNR"] = "000000";
                    dwReturn["ARBESTKZ"] = " ";
                    dwReturn["ARWPKZLT"] = " ";
                    dwReturn["ARMENGE"] = "0";
                    dwReturn["ARSTAFME"] = " ";
                    dwReturn["ARGRUPPE"] = " ";
                    dwReturn["ARWERT"] = "0";
                    dwReturn["ARMRKM1"] = "    ";
                    dwReturn["ARMWERT1"] = "0";
                    dwReturn["ARMKZPA1"] = " ";
                    dwReturn["ARMME1"] = " ";
                    dwReturn["ARMRKM2"] = "    ";
                    dwReturn["ARMWERT2"] = "0";
                    dwReturn["ARMKZPA2"] = " ";
                    dwReturn["ARMME2"] = " ";
                    dwReturn["ARMRKM3"] = "    ";
                    dwReturn["ARMWERT3"] = "0";
                    dwReturn["ARMKZPA3"] = " ";
                    dwReturn["ARMME3"] = " ";
                    dwReturn["ARMRKM4"] = "    ";
                    dwReturn["ARMWERT4"] = "0";
                    dwReturn["ARMKZPA4"] = " ";
                    dwReturn["ARMME4"] = " ";
                    dwReturn["ARMRKM5"] = "    ";
                    dwReturn["ARMWERT5"] = "0";
                    dwReturn["ARMKZPA5"] = " ";
                    dwReturn["ARMME5"] = " ";
                    dwReturn["ARMRKM6"] = "    ";
                    dwReturn["ARMWERT6"] = "0";
                    dwReturn["ARMKZPA6"] = " ";
                    dwReturn["ARMME6"] = " ";
                    dwReturn["ARMRKM7"] = "    ";
                    dwReturn["ARMWERT7"] = "0";
                    dwReturn["ARMKZPA7"] = " ";
                    dwReturn["ARMME7"] = " ";
                    dwReturn["ARMRKM8"] = "    ";
                    dwReturn["ARMWERT8"] = "0";
                    dwReturn["ARMKZPA8"] = " ";
                    dwReturn["ARMME8"] = " ";
                    dwReturn["ARMRKM9"] = "    ";
                    dwReturn["ARMWERT9"] = "0";
                    dwReturn["ARMKZPA9"] = " ";
                    dwReturn["ARMME9"] = " ";
                    dwReturn["ARMRKM10"] = "    ";
                    dwReturn["ARMWERT10"] = "0";
                    dwReturn["ARMKZPA10"] = " ";
                    dwReturn["ARMME10"] = " ";
                    dwReturn["ARANFART1"] = "    ";
                    dwReturn["ARAWERT1"] = "0";
                    dwReturn["ARAKZPA1"] = " ";
                    dwReturn["ARAKZBP1"] = " ";
                    dwReturn["ARAME1"] = " ";
                    dwReturn["ARBEMKZ1"] = " ";
                    dwReturn["ARANFART2"] = "    ";
                    dwReturn["ARAWERT2"] = "0";
                    dwReturn["ARAKZPA2"] = " ";
                    dwReturn["ARAKZBP2"] = " ";
                    dwReturn["ARAME2"] = " ";
                    dwReturn["ARBEMKZ2"] = " ";
                    dwReturn["ARANFART3"] = "    ";
                    dwReturn["ARAWERT3"] = "0";
                    dwReturn["ARAKZPA3"] = " ";
                    dwReturn["ARAKZBP3"] = " ";
                    dwReturn["ARAME3"] = " ";
                    dwReturn["ARBEMKZ3"] = " ";
                    dwReturn["ARANFART4"] = "    ";
                    dwReturn["ARAWERT4"] = "0";
                    dwReturn["ARAKZPA4"] = " ";
                    dwReturn["ARAKZBP4"] = " ";
                    dwReturn["ARAME4"] = " ";
                    dwReturn["ARBEMKZ4"] = " ";
                    dwReturn["ARANFART5"] = "    ";
                    dwReturn["ARAWERT5"] = "0";
                    dwReturn["ARAKZPA5"] = " ";
                    dwReturn["ARAKZBP5"] = " ";
                    dwReturn["ARAME5"] = " ";
                    dwReturn["ARBEMKZ5"] = " ";
                    dwReturn["ARANFART6"] = "    ";
                    dwReturn["ARAWERT6"] = "0";
                    dwReturn["ARAKZPA6"] = " ";
                    dwReturn["ARAKZBP6"] = " ";
                    dwReturn["ARAME6"] = " ";
                    dwReturn["ARBEMKZ6"] = " ";
                    dwReturn["ARANFART7"] = "    ";
                    dwReturn["ARAWERT7"] = "0";
                    dwReturn["ARAKZPA7"] = " ";
                    dwReturn["ARAKZBP7"] = " ";
                    dwReturn["ARAME7"] = " ";
                    dwReturn["ARBEMKZ7"] = " ";
                    dwReturn["ARANFART8"] = "    ";
                    dwReturn["ARAWERT8"] = "0";
                    dwReturn["ARAKZPA8"] = " ";
                    dwReturn["ARAKZBP8"] = " ";
                    dwReturn["ARAME8"] = " ";
                    dwReturn["ARBEMKZ8"] = " ";
                    dwReturn["ARANFART9"] = "    ";
                    dwReturn["ARAWERT9"] = "0";
                    dwReturn["ARAKZPA9"] = " ";
                    dwReturn["ARAKZBP9"] = " ";
                    dwReturn["ARAME9"] = " ";
                    dwReturn["ARBEMKZ9"] = " ";
                    dwReturn["ARANFART10"] = "    ";
                    dwReturn["ARAWERT10"] = "0";
                    dwReturn["ARAKZPA10"] = " ";
                    dwReturn["ARAKZBP10"] = " ";
                    dwReturn["ARAME10"] = " ";
                    dwReturn["ARBEMKZ10"] = " ";
                    dwReturn["ARVALDAT"] = "0";
                    dwReturn["ARZAHLB"] = "   ";
                    dwReturn["ARPAMABR"] = " ";
                    dwReturn["ARAUFWRT"] = "00000000000";
                    dwReturn["ARBERBAS"] = " ";
                    dwReturn["ARFKNVS"] = " ";
                    dwReturn["ARFKSPTD"] = "0";
                    dwReturn["ARFKSPRD"] = "0";
                    dwReturn["ARKSTTKZ"] = "J";
                    dwReturn["ARMINMGE"] = "0";
                    dwReturn["ARMRKMP"] = "    ";
                    dwReturn["ARMWERTP"] = "0";
                    dwReturn["ARRENR"] = "00000000";
                    dwReturn["ARREPOS"] = "000";
                    dwReturn["ARRPREIS"] = "0";
                    dwReturn["ARDRZUSCHL"] = " ";
                    dwReturn["ARBERZUSATZ"] = " ";
                    dwReturn["ARFFAKKZ"] = " ";
                    dwReturn["ARWAEHRSL"] = "   ";
                    dwReturn["ARNIXVV"] = " ";
                    dwReturn["ARABRWERT"] = "0";
                    dwReturn["ARABRFAE"] = " ";
                    dwReturn["ARKUNDNR"] = "00000000";
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARFILLER"] = "50                                            ";
                    dwReturn["ARAENDBEN"] = "        ";
                    dwReturn["ARAENDDAT"] = "0";
                    #endregion
                    break;
                case "JLT":
                    #region====JLT======
                    dwReturn["ARMANDANT"] = "00";
                    dwReturn["ARAUFKRS"] = "T6";
                    dwReturn["ARAUFLFD"] = "001326";
                    dwReturn["ARAUFPOS"] = "001";
                    dwReturn["ARAFOLGE"] = "000";
                    dwReturn["ARKZSPR"] = "N";
                    dwReturn["ARPNRKR"] = "  ";
                    dwReturn["ARPLFDNR"] = "000000";
                    dwReturn["ARBESTKZ"] = "J";
                    dwReturn["ARWPKZLT"] = " ";
                    dwReturn["ARMENGE"] = "0";
                    dwReturn["ARSTAFME"] = " ";
                    dwReturn["ARGRUPPE"] = " ";
                    dwReturn["ARWERT"] = "0";
                    dwReturn["ARMRKM1"] = "    ";
                    dwReturn["ARMWERT1"] = "0";
                    dwReturn["ARMKZPA1"] = " ";
                    dwReturn["ARMME1"] = " ";
                    dwReturn["ARMRKM2"] = "    ";
                    dwReturn["ARMWERT2"] = "0";
                    dwReturn["ARMKZPA2"] = " ";
                    dwReturn["ARMME2"] = " ";
                    dwReturn["ARMRKM3"] = "    ";
                    dwReturn["ARMWERT3"] = "0";
                    dwReturn["ARMKZPA3"] = " ";
                    dwReturn["ARMME3"] = " ";
                    dwReturn["ARMRKM4"] = "    ";
                    dwReturn["ARMWERT4"] = "0";
                    dwReturn["ARMKZPA4"] = " ";
                    dwReturn["ARMME4"] = " ";
                    dwReturn["ARMRKM5"] = "    ";
                    dwReturn["ARMWERT5"] = "0";
                    dwReturn["ARMKZPA5"] = " ";
                    dwReturn["ARMME5"] = " ";
                    dwReturn["ARMRKM6"] = "    ";
                    dwReturn["ARMWERT6"] = "0";
                    dwReturn["ARMKZPA6"] = " ";
                    dwReturn["ARMME6"] = " ";
                    dwReturn["ARMRKM7"] = "    ";
                    dwReturn["ARMWERT7"] = "0";
                    dwReturn["ARMKZPA7"] = " ";
                    dwReturn["ARMME7"] = " ";
                    dwReturn["ARMRKM8"] = "    ";
                    dwReturn["ARMWERT8"] = "0";
                    dwReturn["ARMKZPA8"] = " ";
                    dwReturn["ARMME8"] = " ";
                    dwReturn["ARMRKM9"] = "    ";
                    dwReturn["ARMWERT9"] = "0";
                    dwReturn["ARMKZPA9"] = " ";
                    dwReturn["ARMME9"] = " ";
                    dwReturn["ARMRKM10"] = "    ";
                    dwReturn["ARMWERT10"] = "0";
                    dwReturn["ARMKZPA10"] = " ";
                    dwReturn["ARMME10"] = " ";
                    dwReturn["ARANFART1"] = "    ";
                    dwReturn["ARAWERT1"] = "0";
                    dwReturn["ARAKZPA1"] = " ";
                    dwReturn["ARAKZBP1"] = " ";
                    dwReturn["ARAME1"] = " ";
                    dwReturn["ARBEMKZ1"] = " ";
                    dwReturn["ARANFART2"] = "    ";
                    dwReturn["ARAWERT2"] = "0";
                    dwReturn["ARAKZPA2"] = " ";
                    dwReturn["ARAKZBP2"] = " ";
                    dwReturn["ARAME2"] = " ";
                    dwReturn["ARBEMKZ2"] = " ";
                    dwReturn["ARANFART3"] = "    ";
                    dwReturn["ARAWERT3"] = "0";
                    dwReturn["ARAKZPA3"] = " ";
                    dwReturn["ARAKZBP3"] = " ";
                    dwReturn["ARAME3"] = " ";
                    dwReturn["ARBEMKZ3"] = " ";
                    dwReturn["ARANFART4"] = "    ";
                    dwReturn["ARAWERT4"] = "0";
                    dwReturn["ARAKZPA4"] = " ";
                    dwReturn["ARAKZBP4"] = " ";
                    dwReturn["ARAME4"] = " ";
                    dwReturn["ARBEMKZ4"] = " ";
                    dwReturn["ARANFART5"] = "    ";
                    dwReturn["ARAWERT5"] = "0";
                    dwReturn["ARAKZPA5"] = " ";
                    dwReturn["ARAKZBP5"] = " ";
                    dwReturn["ARAME5"] = " ";
                    dwReturn["ARBEMKZ5"] = " ";
                    dwReturn["ARANFART6"] = "    ";
                    dwReturn["ARAWERT6"] = "0";
                    dwReturn["ARAKZPA6"] = " ";
                    dwReturn["ARAKZBP6"] = " ";
                    dwReturn["ARAME6"] = " ";
                    dwReturn["ARBEMKZ6"] = " ";
                    dwReturn["ARANFART7"] = "    ";
                    dwReturn["ARAWERT7"] = "0";
                    dwReturn["ARAKZPA7"] = " ";
                    dwReturn["ARAKZBP7"] = " ";
                    dwReturn["ARAME7"] = " ";
                    dwReturn["ARBEMKZ7"] = " ";
                    dwReturn["ARANFART8"] = "    ";
                    dwReturn["ARAWERT8"] = "0";
                    dwReturn["ARAKZPA8"] = " ";
                    dwReturn["ARAKZBP8"] = " ";
                    dwReturn["ARAME8"] = " ";
                    dwReturn["ARBEMKZ8"] = " ";
                    dwReturn["ARANFART9"] = "    ";
                    dwReturn["ARAWERT9"] = "0";
                    dwReturn["ARAKZPA9"] = " ";
                    dwReturn["ARAKZBP9"] = " ";
                    dwReturn["ARAME9"] = " ";
                    dwReturn["ARBEMKZ9"] = " ";
                    dwReturn["ARANFART10"] = "    ";
                    dwReturn["ARAWERT10"] = "0";
                    dwReturn["ARAKZPA10"] = " ";
                    dwReturn["ARAKZBP10"] = " ";
                    dwReturn["ARAME10"] = " ";
                    dwReturn["ARBEMKZ10"] = " ";
                    dwReturn["ARVALDAT"] = "0";
                    dwReturn["ARZAHLB"] = "   ";
                    dwReturn["ARPAMABR"] = " ";
                    dwReturn["ARAUFWRT"] = "00000000000";
                    dwReturn["ARBERBAS"] = " ";
                    dwReturn["ARFKNVS"] = " ";
                    dwReturn["ARFKSPTD"] = "0";
                    dwReturn["ARFKSPRD"] = "0";
                    dwReturn["ARKSTTKZ"] = "J";
                    dwReturn["ARMINMGE"] = "0";
                    dwReturn["ARMRKMP"] = "    ";
                    dwReturn["ARMWERTP"] = "0";
                    dwReturn["ARRENR"] = "00000000";
                    dwReturn["ARREPOS"] = "000";
                    dwReturn["ARRPREIS"] = "0";
                    dwReturn["ARDRZUSCHL"] = " ";
                    dwReturn["ARBERZUSATZ"] = " ";
                    dwReturn["ARFFAKKZ"] = " ";
                    dwReturn["ARWAEHRSL"] = "   ";
                    dwReturn["ARNIXVV"] = " ";
                    dwReturn["ARABRWERT"] = "0";
                    dwReturn["ARABRFAE"] = " ";
                    dwReturn["ARKUNDNR"] = "00000000";
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARFILLER"] = "50                                            ";
                    dwReturn["ARAENDBEN"] = "        ";
                    dwReturn["ARAENDDAT"] = "0";

                    #endregion
                    break;
                case "FLT":
                    DataSet SResult = new DataSet();
                    SResult = QueryABPR(dwInput, 0);
                    dwReturn = SResult.Tables[0].Rows[0];
                    #region

                    dwReturn["ARMANDANT"] = "00";
                    dwReturn["ARAUFKRS"] = "D7";
                    dwReturn["ARAUFLFD"] = "000313";
                    dwReturn["ARAUFPOS"] = "012";
                    dwReturn["ARAFOLGE"] = "000";
                    dwReturn["ARKZSPR"] = " ";
                    dwReturn["ARPNRKR"] = "  ";
                    dwReturn["ARPLFDNR"] = "000000";
                    dwReturn["ARBESTKZ"] = "N";
                    dwReturn["ARWPKZLT"] = " ";
                    dwReturn["ARMENGE"] = "0";
                    dwReturn["ARSTAFME"] = " ";
                    dwReturn["ARGRUPPE"] = " ";
                    dwReturn["ARWERT"] = "0";
                    dwReturn["ARMMOD1"] = " ";
                    dwReturn["ARMRKM1"] = "    ";
                    dwReturn["ARMWERT1"] = "0";
                    dwReturn["ARMKZPA1"] = " ";
                    dwReturn["ARMME1"] = " ";
                    dwReturn["ARMMOD2"] = " ";
                    dwReturn["ARMRKM2"] = "    ";
                    dwReturn["ARMWERT2"] = "0";
                    dwReturn["ARMKZPA2"] = " ";
                    dwReturn["ARMME2"] = " ";
                    dwReturn["ARMMOD3"] = " ";
                    dwReturn["ARMRKM3"] = "    ";
                    dwReturn["ARMWERT3"] = "0";
                    dwReturn["ARMKZPA3"] = " ";
                    dwReturn["ARMME3"] = " ";
                    dwReturn["ARMMOD4"] = " ";
                    dwReturn["ARMRKM4"] = "    ";
                    dwReturn["ARMWERT4"] = "0";
                    dwReturn["ARMKZPA4"] = " ";
                    dwReturn["ARMME4"] = " ";
                    dwReturn["ARMMOD5"] = " ";
                    dwReturn["ARMRKM5"] = "    ";
                    dwReturn["ARMWERT5"] = "0";
                    dwReturn["ARMKZPA5"] = " ";
                    dwReturn["ARMME5"] = " ";
                    dwReturn["ARMMOD6"] = " ";
                    dwReturn["ARMRKM6"] = "    ";
                    dwReturn["ARMWERT6"] = "0";
                    dwReturn["ARMKZPA6"] = " ";
                    dwReturn["ARMME6"] = " ";
                    dwReturn["ARMMOD7"] = " ";
                    dwReturn["ARMRKM7"] = "    ";
                    dwReturn["ARMWERT7"] = "0";
                    dwReturn["ARMKZPA7"] = " ";
                    dwReturn["ARMME7"] = " ";
                    dwReturn["ARMMOD8"] = " ";
                    dwReturn["ARMRKM8"] = "    ";
                    dwReturn["ARMWERT8"] = "0";
                    dwReturn["ARMKZPA8"] = " ";
                    dwReturn["ARMME8"] = " ";
                    dwReturn["ARMMOD9"] = " ";
                    dwReturn["ARMRKM9"] = "    ";
                    dwReturn["ARMWERT9"] = "0";
                    dwReturn["ARMKZPA9"] = " ";
                    dwReturn["ARMME9"] = " ";
                    dwReturn["ARMMOD10"] = " ";
                    dwReturn["ARMRKM10"] = "    ";
                    dwReturn["ARMWERT10"] = "0";
                    dwReturn["ARMKZPA10"] = " ";
                    dwReturn["ARMME10"] = " ";
                    dwReturn["ARAMOD1"] = " ";
                    dwReturn["ARANFART1"] = "    ";
                    dwReturn["ARAWERT1"] = "0";
                    dwReturn["ARAKZPA1"] = " ";
                    dwReturn["ARAKZBP1"] = " ";
                    dwReturn["ARAME1"] = " ";
                    dwReturn["ARBEMKZ1"] = " ";
                    dwReturn["ARAMOD2"] = " ";
                    dwReturn["ARANFART2"] = "    ";
                    dwReturn["ARAWERT2"] = "0";
                    dwReturn["ARAKZPA2"] = " ";
                    dwReturn["ARAKZBP2"] = " ";
                    dwReturn["ARAME2"] = " ";
                    dwReturn["ARBEMKZ2"] = " ";
                    dwReturn["ARAMOD3"] = " ";
                    dwReturn["ARANFART3"] = "    ";
                    dwReturn["ARAWERT3"] = "0";
                    dwReturn["ARAKZPA3"] = " ";
                    dwReturn["ARAKZBP3"] = " ";
                    dwReturn["ARAME3"] = " ";
                    dwReturn["ARBEMKZ3"] = " ";
                    dwReturn["ARAMOD4"] = " ";
                    dwReturn["ARANFART4"] = "    ";
                    dwReturn["ARAWERT4"] = "0";
                    dwReturn["ARAKZPA4"] = " ";
                    dwReturn["ARAKZBP4"] = " ";
                    dwReturn["ARAME4"] = " ";
                    dwReturn["ARBEMKZ4"] = " ";
                    dwReturn["ARAMOD5"] = " ";
                    dwReturn["ARANFART5"] = "    ";
                    dwReturn["ARAWERT5"] = "0";
                    dwReturn["ARAKZPA5"] = " ";
                    dwReturn["ARAKZBP5"] = " ";
                    dwReturn["ARAME5"] = " ";
                    dwReturn["ARBEMKZ5"] = " ";
                    dwReturn["ARAMOD6"] = " ";
                    dwReturn["ARANFART6"] = "    ";
                    dwReturn["ARAWERT6"] = "0";
                    dwReturn["ARAKZPA6"] = " ";
                    dwReturn["ARAKZBP6"] = " ";
                    dwReturn["ARAME6"] = " ";
                    dwReturn["ARBEMKZ6"] = " ";
                    dwReturn["ARAMOD7"] = " ";
                    dwReturn["ARANFART7"] = "    ";
                    dwReturn["ARAWERT7"] = "0";
                    dwReturn["ARAKZPA7"] = " ";
                    dwReturn["ARAKZBP7"] = " ";
                    dwReturn["ARAME7"] = " ";
                    dwReturn["ARBEMKZ7"] = " ";
                    dwReturn["ARAMOD8"] = " ";
                    dwReturn["ARANFART8"] = "    ";
                    dwReturn["ARAWERT8"] = "0";
                    dwReturn["ARAKZPA8"] = " ";
                    dwReturn["ARAKZBP8"] = " ";
                    dwReturn["ARAME8"] = " ";
                    dwReturn["ARBEMKZ8"] = " ";
                    dwReturn["ARAMOD9"] = " ";
                    dwReturn["ARANFART9"] = "    ";
                    dwReturn["ARAWERT9"] = "0";
                    dwReturn["ARAKZPA9"] = " ";
                    dwReturn["ARAKZBP9"] = " ";
                    dwReturn["ARAME9"] = " ";
                    dwReturn["ARBEMKZ9"] = " ";
                    dwReturn["ARAMOD10"] = " ";
                    dwReturn["ARANFART10"] = "    ";
                    dwReturn["ARAWERT10"] = "0";
                    dwReturn["ARAKZPA10"] = " ";
                    dwReturn["ARAKZBP10"] = " ";
                    dwReturn["ARAME10"] = " ";
                    dwReturn["ARBEMKZ10"] = " ";
                    dwReturn["ARVALDAT"] = "0";
                    dwReturn["ARZAHLB"] = "   ";
                    dwReturn["ARPAMABR"] = " ";
                    dwReturn["ARBERBAS"] = " ";
                    dwReturn["ARFKNVS"] = " ";
                    dwReturn["ARFKSPTD"] = "0";
                    dwReturn["ARFKSPRD"] = "0";
                    dwReturn["ARKSTTKZ"] = "J";
                    dwReturn["ARMINMGE"] = "0";
                    dwReturn["ARMRKMP"] = "    ";
                    dwReturn["ARMWERTP"] = "0";
                    dwReturn["ARRENR"] = "00000000";
                    dwReturn["ARREPOS"] = "000";
                    dwReturn["ARRPREIS"] = "0";
                    dwReturn["ARDRZUSCHL"] = " ";
                    dwReturn["ARBERZUSATZ"] = " ";
                    dwReturn["ARFFAKKZ"] = " ";
                    dwReturn["ARWAEHRSL"] = "   ";
                    dwReturn["ARNIXVV"] = " ";
                    dwReturn["ARABRWERT"] = "0";
                    dwReturn["ARABRFAE"] = " ";
                    dwReturn["ARKUNDNR"] = "00000000";
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARSTATUS"] = "  ";
                    dwReturn["ARFILLER"] = "                                           ";
                    dwReturn["ARAENDBEN"] = "        ";
                    dwReturn["ARAENDDAT"] = "0";
                    #endregion
                    break;
            }
            INTEXDBC.MapData(true, ref dwReturn, dwInput);
            switch (app.company)
            {
                case "FLT":
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARFILLER"] = "                                        ";
                    break;
            }
        }
        public DataRow Convert2ABPR(DataRow dwInput, string AUF, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryABPR(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (AUF)
            {
                case "YGR":
                    #region===="YGR"======
                    dwReturn["ARMANDANT"] = "00";
                    dwReturn["ARAUFKRS"] = "ZT";
                    dwReturn["ARAUFLFD"] = "000004";
                    dwReturn["ARAUFPOS"] = "001";
                    dwReturn["ARAFOLGE"] = "000";
                    dwReturn["ARKZSPR"] = "N";
                    dwReturn["ARPNRKR"] = "  ";
                    dwReturn["ARPLFDNR"] = "000000";
                    dwReturn["ARBESTKZ"] = " ";
                    dwReturn["ARWPKZLT"] = " ";
                    dwReturn["ARMENGE"] = "0";
                    dwReturn["ARSTAFME"] = " ";
                    dwReturn["ARGRUPPE"] = " ";
                    dwReturn["ARWERT"] = "0";
                    dwReturn["ARMRKM1"] = "    ";
                    dwReturn["ARMWERT1"] = "0";
                    dwReturn["ARMKZPA1"] = " ";
                    dwReturn["ARMME1"] = " ";
                    dwReturn["ARMRKM2"] = "    ";
                    dwReturn["ARMWERT2"] = "0";
                    dwReturn["ARMKZPA2"] = " ";
                    dwReturn["ARMME2"] = " ";
                    dwReturn["ARMRKM3"] = "    ";
                    dwReturn["ARMWERT3"] = "0";
                    dwReturn["ARMKZPA3"] = " ";
                    dwReturn["ARMME3"] = " ";
                    dwReturn["ARMRKM4"] = "    ";
                    dwReturn["ARMWERT4"] = "0";
                    dwReturn["ARMKZPA4"] = " ";
                    dwReturn["ARMME4"] = " ";
                    dwReturn["ARMRKM5"] = "    ";
                    dwReturn["ARMWERT5"] = "0";
                    dwReturn["ARMKZPA5"] = " ";
                    dwReturn["ARMME5"] = " ";
                    dwReturn["ARMRKM6"] = "    ";
                    dwReturn["ARMWERT6"] = "0";
                    dwReturn["ARMKZPA6"] = " ";
                    dwReturn["ARMME6"] = " ";
                    dwReturn["ARMRKM7"] = "    ";
                    dwReturn["ARMWERT7"] = "0";
                    dwReturn["ARMKZPA7"] = " ";
                    dwReturn["ARMME7"] = " ";
                    dwReturn["ARMRKM8"] = "    ";
                    dwReturn["ARMWERT8"] = "0";
                    dwReturn["ARMKZPA8"] = " ";
                    dwReturn["ARMME8"] = " ";
                    dwReturn["ARMRKM9"] = "    ";
                    dwReturn["ARMWERT9"] = "0";
                    dwReturn["ARMKZPA9"] = " ";
                    dwReturn["ARMME9"] = " ";
                    dwReturn["ARMRKM10"] = "    ";
                    dwReturn["ARMWERT10"] = "0";
                    dwReturn["ARMKZPA10"] = " ";
                    dwReturn["ARMME10"] = " ";
                    dwReturn["ARANFART1"] = "    ";
                    dwReturn["ARAWERT1"] = "0";
                    dwReturn["ARAKZPA1"] = " ";
                    dwReturn["ARAKZBP1"] = " ";
                    dwReturn["ARAME1"] = " ";
                    dwReturn["ARBEMKZ1"] = " ";
                    dwReturn["ARANFART2"] = "    ";
                    dwReturn["ARAWERT2"] = "0";
                    dwReturn["ARAKZPA2"] = " ";
                    dwReturn["ARAKZBP2"] = " ";
                    dwReturn["ARAME2"] = " ";
                    dwReturn["ARBEMKZ2"] = " ";
                    dwReturn["ARANFART3"] = "    ";
                    dwReturn["ARAWERT3"] = "0";
                    dwReturn["ARAKZPA3"] = " ";
                    dwReturn["ARAKZBP3"] = " ";
                    dwReturn["ARAME3"] = " ";
                    dwReturn["ARBEMKZ3"] = " ";
                    dwReturn["ARANFART4"] = "    ";
                    dwReturn["ARAWERT4"] = "0";
                    dwReturn["ARAKZPA4"] = " ";
                    dwReturn["ARAKZBP4"] = " ";
                    dwReturn["ARAME4"] = " ";
                    dwReturn["ARBEMKZ4"] = " ";
                    dwReturn["ARANFART5"] = "    ";
                    dwReturn["ARAWERT5"] = "0";
                    dwReturn["ARAKZPA5"] = " ";
                    dwReturn["ARAKZBP5"] = " ";
                    dwReturn["ARAME5"] = " ";
                    dwReturn["ARBEMKZ5"] = " ";
                    dwReturn["ARANFART6"] = "    ";
                    dwReturn["ARAWERT6"] = "0";
                    dwReturn["ARAKZPA6"] = " ";
                    dwReturn["ARAKZBP6"] = " ";
                    dwReturn["ARAME6"] = " ";
                    dwReturn["ARBEMKZ6"] = " ";
                    dwReturn["ARANFART7"] = "    ";
                    dwReturn["ARAWERT7"] = "0";
                    dwReturn["ARAKZPA7"] = " ";
                    dwReturn["ARAKZBP7"] = " ";
                    dwReturn["ARAME7"] = " ";
                    dwReturn["ARBEMKZ7"] = " ";
                    dwReturn["ARANFART8"] = "    ";
                    dwReturn["ARAWERT8"] = "0";
                    dwReturn["ARAKZPA8"] = " ";
                    dwReturn["ARAKZBP8"] = " ";
                    dwReturn["ARAME8"] = " ";
                    dwReturn["ARBEMKZ8"] = " ";
                    dwReturn["ARANFART9"] = "    ";
                    dwReturn["ARAWERT9"] = "0";
                    dwReturn["ARAKZPA9"] = " ";
                    dwReturn["ARAKZBP9"] = " ";
                    dwReturn["ARAME9"] = " ";
                    dwReturn["ARBEMKZ9"] = " ";
                    dwReturn["ARANFART10"] = "    ";
                    dwReturn["ARAWERT10"] = "0";
                    dwReturn["ARAKZPA10"] = " ";
                    dwReturn["ARAKZBP10"] = " ";
                    dwReturn["ARAME10"] = " ";
                    dwReturn["ARBEMKZ10"] = " ";
                    dwReturn["ARVALDAT"] = "0";
                    dwReturn["ARZAHLB"] = "   ";
                    dwReturn["ARPAMABR"] = " ";
                    dwReturn["ARAUFWRT"] = "00000000000";
                    dwReturn["ARBERBAS"] = " ";
                    dwReturn["ARFKNVS"] = " ";
                    dwReturn["ARFKSPTD"] = "0";
                    dwReturn["ARFKSPRD"] = "0";
                    dwReturn["ARKSTTKZ"] = "J";
                    dwReturn["ARMINMGE"] = "0";
                    dwReturn["ARMRKMP"] = "    ";
                    dwReturn["ARMWERTP"] = "0";
                    dwReturn["ARRENR"] = "00000000";
                    dwReturn["ARREPOS"] = "000";
                    dwReturn["ARRPREIS"] = "0";
                    dwReturn["ARDRZUSCHL"] = " ";
                    dwReturn["ARBERZUSATZ"] = " ";
                    dwReturn["ARFFAKKZ"] = " ";
                    dwReturn["ARWAEHRSL"] = "   ";
                    dwReturn["ARNIXVV"] = " ";
                    dwReturn["ARABRWERT"] = "0";
                    dwReturn["ARABRFAE"] = " ";
                    dwReturn["ARKUNDNR"] = "00000000";
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARFILLER"] = "50                                            ";
                    dwReturn["ARAENDBEN"] = "        ";
                    dwReturn["ARAENDDAT"] = "0";
                    #endregion
                    break;
                case "JLT":
                    #region====JLT======
                    dwReturn["ARMANDANT"] = "00";
                    dwReturn["ARAUFKRS"] = "T6";
                    dwReturn["ARAUFLFD"] = "001326";
                    dwReturn["ARAUFPOS"] = "001";
                    dwReturn["ARAFOLGE"] = "000";
                    dwReturn["ARKZSPR"] = "N";
                    dwReturn["ARPNRKR"] = "  ";
                    dwReturn["ARPLFDNR"] = "000000";
                    dwReturn["ARBESTKZ"] = "J";
                    dwReturn["ARWPKZLT"] = " ";
                    dwReturn["ARMENGE"] = "0";
                    dwReturn["ARSTAFME"] = " ";
                    dwReturn["ARGRUPPE"] = " ";
                    dwReturn["ARWERT"] = "0";
                    dwReturn["ARMRKM1"] = "    ";
                    dwReturn["ARMWERT1"] = "0";
                    dwReturn["ARMKZPA1"] = " ";
                    dwReturn["ARMME1"] = " ";
                    dwReturn["ARMRKM2"] = "    ";
                    dwReturn["ARMWERT2"] = "0";
                    dwReturn["ARMKZPA2"] = " ";
                    dwReturn["ARMME2"] = " ";
                    dwReturn["ARMRKM3"] = "    ";
                    dwReturn["ARMWERT3"] = "0";
                    dwReturn["ARMKZPA3"] = " ";
                    dwReturn["ARMME3"] = " ";
                    dwReturn["ARMRKM4"] = "    ";
                    dwReturn["ARMWERT4"] = "0";
                    dwReturn["ARMKZPA4"] = " ";
                    dwReturn["ARMME4"] = " ";
                    dwReturn["ARMRKM5"] = "    ";
                    dwReturn["ARMWERT5"] = "0";
                    dwReturn["ARMKZPA5"] = " ";
                    dwReturn["ARMME5"] = " ";
                    dwReturn["ARMRKM6"] = "    ";
                    dwReturn["ARMWERT6"] = "0";
                    dwReturn["ARMKZPA6"] = " ";
                    dwReturn["ARMME6"] = " ";
                    dwReturn["ARMRKM7"] = "    ";
                    dwReturn["ARMWERT7"] = "0";
                    dwReturn["ARMKZPA7"] = " ";
                    dwReturn["ARMME7"] = " ";
                    dwReturn["ARMRKM8"] = "    ";
                    dwReturn["ARMWERT8"] = "0";
                    dwReturn["ARMKZPA8"] = " ";
                    dwReturn["ARMME8"] = " ";
                    dwReturn["ARMRKM9"] = "    ";
                    dwReturn["ARMWERT9"] = "0";
                    dwReturn["ARMKZPA9"] = " ";
                    dwReturn["ARMME9"] = " ";
                    dwReturn["ARMRKM10"] = "    ";
                    dwReturn["ARMWERT10"] = "0";
                    dwReturn["ARMKZPA10"] = " ";
                    dwReturn["ARMME10"] = " ";
                    dwReturn["ARANFART1"] = "    ";
                    dwReturn["ARAWERT1"] = "0";
                    dwReturn["ARAKZPA1"] = " ";
                    dwReturn["ARAKZBP1"] = " ";
                    dwReturn["ARAME1"] = " ";
                    dwReturn["ARBEMKZ1"] = " ";
                    dwReturn["ARANFART2"] = "    ";
                    dwReturn["ARAWERT2"] = "0";
                    dwReturn["ARAKZPA2"] = " ";
                    dwReturn["ARAKZBP2"] = " ";
                    dwReturn["ARAME2"] = " ";
                    dwReturn["ARBEMKZ2"] = " ";
                    dwReturn["ARANFART3"] = "    ";
                    dwReturn["ARAWERT3"] = "0";
                    dwReturn["ARAKZPA3"] = " ";
                    dwReturn["ARAKZBP3"] = " ";
                    dwReturn["ARAME3"] = " ";
                    dwReturn["ARBEMKZ3"] = " ";
                    dwReturn["ARANFART4"] = "    ";
                    dwReturn["ARAWERT4"] = "0";
                    dwReturn["ARAKZPA4"] = " ";
                    dwReturn["ARAKZBP4"] = " ";
                    dwReturn["ARAME4"] = " ";
                    dwReturn["ARBEMKZ4"] = " ";
                    dwReturn["ARANFART5"] = "    ";
                    dwReturn["ARAWERT5"] = "0";
                    dwReturn["ARAKZPA5"] = " ";
                    dwReturn["ARAKZBP5"] = " ";
                    dwReturn["ARAME5"] = " ";
                    dwReturn["ARBEMKZ5"] = " ";
                    dwReturn["ARANFART6"] = "    ";
                    dwReturn["ARAWERT6"] = "0";
                    dwReturn["ARAKZPA6"] = " ";
                    dwReturn["ARAKZBP6"] = " ";
                    dwReturn["ARAME6"] = " ";
                    dwReturn["ARBEMKZ6"] = " ";
                    dwReturn["ARANFART7"] = "    ";
                    dwReturn["ARAWERT7"] = "0";
                    dwReturn["ARAKZPA7"] = " ";
                    dwReturn["ARAKZBP7"] = " ";
                    dwReturn["ARAME7"] = " ";
                    dwReturn["ARBEMKZ7"] = " ";
                    dwReturn["ARANFART8"] = "    ";
                    dwReturn["ARAWERT8"] = "0";
                    dwReturn["ARAKZPA8"] = " ";
                    dwReturn["ARAKZBP8"] = " ";
                    dwReturn["ARAME8"] = " ";
                    dwReturn["ARBEMKZ8"] = " ";
                    dwReturn["ARANFART9"] = "    ";
                    dwReturn["ARAWERT9"] = "0";
                    dwReturn["ARAKZPA9"] = " ";
                    dwReturn["ARAKZBP9"] = " ";
                    dwReturn["ARAME9"] = " ";
                    dwReturn["ARBEMKZ9"] = " ";
                    dwReturn["ARANFART10"] = "    ";
                    dwReturn["ARAWERT10"] = "0";
                    dwReturn["ARAKZPA10"] = " ";
                    dwReturn["ARAKZBP10"] = " ";
                    dwReturn["ARAME10"] = " ";
                    dwReturn["ARBEMKZ10"] = " ";
                    dwReturn["ARVALDAT"] = "0";
                    dwReturn["ARZAHLB"] = "   ";
                    dwReturn["ARPAMABR"] = " ";
                    dwReturn["ARAUFWRT"] = "00000000000";
                    dwReturn["ARBERBAS"] = " ";
                    dwReturn["ARFKNVS"] = " ";
                    dwReturn["ARFKSPTD"] = "0";
                    dwReturn["ARFKSPRD"] = "0";
                    dwReturn["ARKSTTKZ"] = "J";
                    dwReturn["ARMINMGE"] = "0";
                    dwReturn["ARMRKMP"] = "    ";
                    dwReturn["ARMWERTP"] = "0";
                    dwReturn["ARRENR"] = "00000000";
                    dwReturn["ARREPOS"] = "000";
                    dwReturn["ARRPREIS"] = "0";
                    dwReturn["ARDRZUSCHL"] = " ";
                    dwReturn["ARBERZUSATZ"] = " ";
                    dwReturn["ARFFAKKZ"] = " ";
                    dwReturn["ARWAEHRSL"] = "   ";
                    dwReturn["ARNIXVV"] = " ";
                    dwReturn["ARABRWERT"] = "0";
                    dwReturn["ARABRFAE"] = " ";
                    dwReturn["ARKUNDNR"] = "00000000";
                    dwReturn["ARLIEFNR"] = "        ";
                    dwReturn["ARFILLER"] = "50                                            ";
                    dwReturn["ARAENDBEN"] = "        ";
                    dwReturn["ARAENDDAT"] = "0";

                    #endregion
                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void SaveABPR(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryABPR(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapABPR(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertABPR(dwLocal, ITXDBVERSION);
            }
            UpdateABPR(dwLocal);
        }
        public void MapABPR(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public DataSet QueryABPR(DataRow dwData, int option = 1)
        { 
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:SResult = QABPR00(dwData);break;
                case 1: SResult = QABPR01(dwData); break;
                case 2: SResult = QABPR02(dwData); break;
                case 4: SResult = QABPR04(dwData); break;
                default:
                    break;
            }
           
            return SResult;
        }
        public DataSet QABPR01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM ABPR WHERE  "
                  + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QABPR00(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM ABPR WHERE  "
                  + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QABPR04(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM ABPR WHERE  "
                    + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QABPR02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM ABPR WHERE  "
                    + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QABPR03(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT P.*,WTGFDISM,WTGNFTOLM,WTGNFTOLP FROM ABPR P   "
                + " JOIN ABPOS ON ABPMANDANT=ARMANDANT AND ABPAUFKRS=ARAUFKRS AND ABPAUFLFD=ARAUFLFD AND ABPAUFPOS=ARAUFPOS"
                +" JOIN WASTAMM ON ABPMANDANT=WAMANDANT AND ABPART=WAART AND SUBSTR(ABPVAR,1,2)=WAVAR "
                + " JOIN WTGEW ON WTGMANDANT=WAMANDANT  AND WTGART=WAART AND  WTGVAR=WAVAR"
                  + " WHERE ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public void DeleteABPR(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ABPR WHERE   ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
            }
           
        }
        public void UpdateABPR(DataRow dwData, int option = 1)
        {
            switch (app.company)
            {
                case "JLT":
                    option = 1;
                    break;
                case "FLT":
                    option = 2;
                    break;
                default:
                case "YGR":
                    option = 3;
                    break;
            }
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region========
                    or1.CommandText = "UPDATE ABPR SET "
             + "ARMANDANT=:ARMANDANT,"
             + "ARAUFKRS=:ARAUFKRS,"
             + "ARAUFLFD=:ARAUFLFD,"
             + "ARAUFPOS=:ARAUFPOS,"
             + "ARAFOLGE=:ARAFOLGE,"
             + "ARKZSPR=:ARKZSPR,"
             + "ARPNRKR=:ARPNRKR,"
             + "ARPLFDNR=:ARPLFDNR,"
             + "ARBESTKZ=:ARBESTKZ,"
             + "ARWPKZLT=:ARWPKZLT,"
             + "ARMENGE=:ARMENGE,"
             + "ARSTAFME=:ARSTAFME,"
             + "ARGRUPPE=:ARGRUPPE,"
             + "ARWERT=:ARWERT,"
             + "ARMRKM1=:ARMRKM1,"
             + "ARMWERT1=:ARMWERT1,"
             + "ARMKZPA1=:ARMKZPA1,"
             + "ARMME1=:ARMME1,"
             + "ARMRKM2=:ARMRKM2,"
             + "ARMWERT2=:ARMWERT2,"
             + "ARMKZPA2=:ARMKZPA2,"
             + "ARMME2=:ARMME2,"
             + "ARMRKM3=:ARMRKM3,"
             + "ARMWERT3=:ARMWERT3,"
             + "ARMKZPA3=:ARMKZPA3,"
             + "ARMME3=:ARMME3,"
             + "ARMRKM4=:ARMRKM4,"
             + "ARMWERT4=:ARMWERT4,"
             + "ARMKZPA4=:ARMKZPA4,"
             + "ARMME4=:ARMME4,"
             + "ARMRKM5=:ARMRKM5,"
             + "ARMWERT5=:ARMWERT5,"
             + "ARMKZPA5=:ARMKZPA5,"
             + "ARMME5=:ARMME5,"
             + "ARMRKM6=:ARMRKM6,"
             + "ARMWERT6=:ARMWERT6,"
             + "ARMKZPA6=:ARMKZPA6,"
             + "ARMME6=:ARMME6,"
             + "ARMRKM7=:ARMRKM7,"
             + "ARMWERT7=:ARMWERT7,"
             + "ARMKZPA7=:ARMKZPA7,"
             + "ARMME7=:ARMME7,"
             + "ARMRKM8=:ARMRKM8,"
             + "ARMWERT8=:ARMWERT8,"
             + "ARMKZPA8=:ARMKZPA8,"
             + "ARMME8=:ARMME8,"
             + "ARMRKM9=:ARMRKM9,"
             + "ARMWERT9=:ARMWERT9,"
             + "ARMKZPA9=:ARMKZPA9,"
             + "ARMME9=:ARMME9,"
             + "ARMRKM10=:ARMRKM10,"
             + "ARMWERT10=:ARMWERT10,"
             + "ARMKZPA10=:ARMKZPA10,"
             + "ARMME10=:ARMME10,"
             + "ARANFART1=:ARANFART1,"
             + "ARAWERT1=:ARAWERT1,"
             + "ARAKZPA1=:ARAKZPA1,"
             + "ARAKZBP1=:ARAKZBP1,"
             + "ARAME1=:ARAME1,"
             + "ARBEMKZ1=:ARBEMKZ1,"
             + "ARANFART2=:ARANFART2,"
             + "ARAWERT2=:ARAWERT2,"
             + "ARAKZPA2=:ARAKZPA2,"
             + "ARAKZBP2=:ARAKZBP2,"
             + "ARAME2=:ARAME2,"
             + "ARBEMKZ2=:ARBEMKZ2,"
             + "ARANFART3=:ARANFART3,"
             + "ARAWERT3=:ARAWERT3,"
             + "ARAKZPA3=:ARAKZPA3,"
             + "ARAKZBP3=:ARAKZBP3,"
             + "ARAME3=:ARAME3,"
             + "ARBEMKZ3=:ARBEMKZ3,"
             + "ARANFART4=:ARANFART4,"
             + "ARAWERT4=:ARAWERT4,"
             + "ARAKZPA4=:ARAKZPA4,"
             + "ARAKZBP4=:ARAKZBP4,"
             + "ARAME4=:ARAME4,"
             + "ARBEMKZ4=:ARBEMKZ4,"
             + "ARANFART5=:ARANFART5,"
             + "ARAWERT5=:ARAWERT5,"
             + "ARAKZPA5=:ARAKZPA5,"
             + "ARAKZBP5=:ARAKZBP5,"
             + "ARAME5=:ARAME5,"
             + "ARBEMKZ5=:ARBEMKZ5,"
             + "ARANFART6=:ARANFART6,"
             + "ARAWERT6=:ARAWERT6,"
             + "ARAKZPA6=:ARAKZPA6,"
             + "ARAKZBP6=:ARAKZBP6,"
             + "ARAME6=:ARAME6,"
             + "ARBEMKZ6=:ARBEMKZ6,"
             + "ARANFART7=:ARANFART7,"
             + "ARAWERT7=:ARAWERT7,"
             + "ARAKZPA7=:ARAKZPA7,"
             + "ARAKZBP7=:ARAKZBP7,"
             + "ARAME7=:ARAME7,"
             + "ARBEMKZ7=:ARBEMKZ7,"
             + "ARANFART8=:ARANFART8,"
             + "ARAWERT8=:ARAWERT8,"
             + "ARAKZPA8=:ARAKZPA8,"
             + "ARAKZBP8=:ARAKZBP8,"
             + "ARAME8=:ARAME8,"
             + "ARBEMKZ8=:ARBEMKZ8,"
             + "ARANFART9=:ARANFART9,"
             + "ARAWERT9=:ARAWERT9,"
             + "ARAKZPA9=:ARAKZPA9,"
             + "ARAKZBP9=:ARAKZBP9,"
             + "ARAME9=:ARAME9,"
             + "ARBEMKZ9=:ARBEMKZ9,"
             + "ARANFART10=:ARANFART10,"
             + "ARAWERT10=:ARAWERT10,"
             + "ARAKZPA10=:ARAKZPA10,"
             + "ARAKZBP10=:ARAKZBP10,"
             + "ARAME10=:ARAME10,"
             + "ARBEMKZ10=:ARBEMKZ10,"
             + "ARVALDAT=:ARVALDAT,"
             + "ARZAHLB=:ARZAHLB,"
             + "ARPAMABR=:ARPAMABR,"
             + "ARAUFWRT=:ARAUFWRT,"
             + "ARBERBAS=:ARBERBAS,"
             + "ARFKNVS=:ARFKNVS,"
             + "ARFKSPTD=:ARFKSPTD,"
             + "ARFKSPRD=:ARFKSPRD,"
             + "ARKSTTKZ=:ARKSTTKZ,"
             + "ARMINMGE=:ARMINMGE,"
             + "ARMRKMP=:ARMRKMP,"
             + "ARMWERTP=:ARMWERTP,"
             + "ARRENR=:ARRENR,"
             + "ARREPOS=:ARREPOS,"
             + "ARRPREIS=:ARRPREIS,"
             + "ARDRZUSCHL=:ARDRZUSCHL,"
             + "ARBERZUSATZ=:ARBERZUSATZ,"
             + "ARFFAKKZ=:ARFFAKKZ,"
             + "ARWAEHRSL=:ARWAEHRSL,"
             + "ARNIXVV=:ARNIXVV,"
             + "ARABRWERT=:ARABRWERT,"
             + "ARABRFAE=:ARABRFAE,"
             + "ARKUNDNR=:ARKUNDNR,"
             + "ARLIEFNR=:ARLIEFNR,"
             + "ARFILLER=:ARFILLER,"
             + "ARAENDBEN=:ARAENDBEN,"
             + "ARAENDDAT=:ARAENDDAT"
             + " WHERE  "
             + "  ARMANDANT=:ARMANDANT AND ARAUFKRS=:ARAUFKRS  AND ARAUFLFD=:ARAUFLFD AND ARAUFPOS=:ARAUFPOS";

                    or1.Parameters.Add("ARMANDANT", OracleType.NVarChar).Value = dwData["ARMANDANT"].ToString();
                    or1.Parameters.Add("ARAUFKRS", OracleType.NVarChar).Value = dwData["ARAUFKRS"].ToString();
                    or1.Parameters.Add("ARAUFLFD", OracleType.NVarChar).Value = dwData["ARAUFLFD"].ToString();
                    or1.Parameters.Add("ARAUFPOS", OracleType.NVarChar).Value = dwData["ARAUFPOS"].ToString();
                    or1.Parameters.Add("ARAFOLGE", OracleType.NVarChar).Value = dwData["ARAFOLGE"].ToString();
                    or1.Parameters.Add("ARKZSPR", OracleType.NVarChar).Value = dwData["ARKZSPR"].ToString();
                    or1.Parameters.Add("ARPNRKR", OracleType.NVarChar).Value = dwData["ARPNRKR"].ToString();
                    or1.Parameters.Add("ARPLFDNR", OracleType.NVarChar).Value = dwData["ARPLFDNR"].ToString();
                    or1.Parameters.Add("ARBESTKZ", OracleType.NVarChar).Value = dwData["ARBESTKZ"].ToString();
                    or1.Parameters.Add("ARWPKZLT", OracleType.NVarChar).Value = dwData["ARWPKZLT"].ToString();
                    or1.Parameters.Add("ARMENGE", OracleType.NVarChar).Value = dwData["ARMENGE"].ToString();
                    or1.Parameters.Add("ARSTAFME", OracleType.NVarChar).Value = dwData["ARSTAFME"].ToString();
                    or1.Parameters.Add("ARGRUPPE", OracleType.NVarChar).Value = dwData["ARGRUPPE"].ToString();
                    or1.Parameters.Add("ARWERT", OracleType.NVarChar).Value = dwData["ARWERT"].ToString();
                    or1.Parameters.Add("ARMRKM1", OracleType.NVarChar).Value = dwData["ARMRKM1"].ToString();
                    or1.Parameters.Add("ARMWERT1", OracleType.NVarChar).Value = dwData["ARMWERT1"].ToString();
                    or1.Parameters.Add("ARMKZPA1", OracleType.NVarChar).Value = dwData["ARMKZPA1"].ToString();
                    or1.Parameters.Add("ARMME1", OracleType.NVarChar).Value = dwData["ARMME1"].ToString();
                    or1.Parameters.Add("ARMRKM2", OracleType.NVarChar).Value = dwData["ARMRKM2"].ToString();
                    or1.Parameters.Add("ARMWERT2", OracleType.NVarChar).Value = dwData["ARMWERT2"].ToString();
                    or1.Parameters.Add("ARMKZPA2", OracleType.NVarChar).Value = dwData["ARMKZPA2"].ToString();
                    or1.Parameters.Add("ARMME2", OracleType.NVarChar).Value = dwData["ARMME2"].ToString();
                    or1.Parameters.Add("ARMRKM3", OracleType.NVarChar).Value = dwData["ARMRKM3"].ToString();
                    or1.Parameters.Add("ARMWERT3", OracleType.NVarChar).Value = dwData["ARMWERT3"].ToString();
                    or1.Parameters.Add("ARMKZPA3", OracleType.NVarChar).Value = dwData["ARMKZPA3"].ToString();
                    or1.Parameters.Add("ARMME3", OracleType.NVarChar).Value = dwData["ARMME3"].ToString();
                    or1.Parameters.Add("ARMRKM4", OracleType.NVarChar).Value = dwData["ARMRKM4"].ToString();
                    or1.Parameters.Add("ARMWERT4", OracleType.NVarChar).Value = dwData["ARMWERT4"].ToString();
                    or1.Parameters.Add("ARMKZPA4", OracleType.NVarChar).Value = dwData["ARMKZPA4"].ToString();
                    or1.Parameters.Add("ARMME4", OracleType.NVarChar).Value = dwData["ARMME4"].ToString();
                    or1.Parameters.Add("ARMRKM5", OracleType.NVarChar).Value = dwData["ARMRKM5"].ToString();
                    or1.Parameters.Add("ARMWERT5", OracleType.NVarChar).Value = dwData["ARMWERT5"].ToString();
                    or1.Parameters.Add("ARMKZPA5", OracleType.NVarChar).Value = dwData["ARMKZPA5"].ToString();
                    or1.Parameters.Add("ARMME5", OracleType.NVarChar).Value = dwData["ARMME5"].ToString();
                    or1.Parameters.Add("ARMRKM6", OracleType.NVarChar).Value = dwData["ARMRKM6"].ToString();
                    or1.Parameters.Add("ARMWERT6", OracleType.NVarChar).Value = dwData["ARMWERT6"].ToString();
                    or1.Parameters.Add("ARMKZPA6", OracleType.NVarChar).Value = dwData["ARMKZPA6"].ToString();
                    or1.Parameters.Add("ARMME6", OracleType.NVarChar).Value = dwData["ARMME6"].ToString();
                    or1.Parameters.Add("ARMRKM7", OracleType.NVarChar).Value = dwData["ARMRKM7"].ToString();
                    or1.Parameters.Add("ARMWERT7", OracleType.NVarChar).Value = dwData["ARMWERT7"].ToString();
                    or1.Parameters.Add("ARMKZPA7", OracleType.NVarChar).Value = dwData["ARMKZPA7"].ToString();
                    or1.Parameters.Add("ARMME7", OracleType.NVarChar).Value = dwData["ARMME7"].ToString();
                    or1.Parameters.Add("ARMRKM8", OracleType.NVarChar).Value = dwData["ARMRKM8"].ToString();
                    or1.Parameters.Add("ARMWERT8", OracleType.NVarChar).Value = dwData["ARMWERT8"].ToString();
                    or1.Parameters.Add("ARMKZPA8", OracleType.NVarChar).Value = dwData["ARMKZPA8"].ToString();
                    or1.Parameters.Add("ARMME8", OracleType.NVarChar).Value = dwData["ARMME8"].ToString();
                    or1.Parameters.Add("ARMRKM9", OracleType.NVarChar).Value = dwData["ARMRKM9"].ToString();
                    or1.Parameters.Add("ARMWERT9", OracleType.NVarChar).Value = dwData["ARMWERT9"].ToString();
                    or1.Parameters.Add("ARMKZPA9", OracleType.NVarChar).Value = dwData["ARMKZPA9"].ToString();
                    or1.Parameters.Add("ARMME9", OracleType.NVarChar).Value = dwData["ARMME9"].ToString();
                    or1.Parameters.Add("ARMRKM10", OracleType.NVarChar).Value = dwData["ARMRKM10"].ToString();
                    or1.Parameters.Add("ARMWERT10", OracleType.NVarChar).Value = dwData["ARMWERT10"].ToString();
                    or1.Parameters.Add("ARMKZPA10", OracleType.NVarChar).Value = dwData["ARMKZPA10"].ToString();
                    or1.Parameters.Add("ARMME10", OracleType.NVarChar).Value = dwData["ARMME10"].ToString();
                    or1.Parameters.Add("ARANFART1", OracleType.NVarChar).Value = dwData["ARANFART1"].ToString();
                    or1.Parameters.Add("ARAWERT1", OracleType.NVarChar).Value = dwData["ARAWERT1"].ToString();
                    or1.Parameters.Add("ARAKZPA1", OracleType.NVarChar).Value = dwData["ARAKZPA1"].ToString();
                    or1.Parameters.Add("ARAKZBP1", OracleType.NVarChar).Value = dwData["ARAKZBP1"].ToString();
                    or1.Parameters.Add("ARAME1", OracleType.NVarChar).Value = dwData["ARAME1"].ToString();
                    or1.Parameters.Add("ARBEMKZ1", OracleType.NVarChar).Value = dwData["ARBEMKZ1"].ToString();
                    or1.Parameters.Add("ARANFART2", OracleType.NVarChar).Value = dwData["ARANFART2"].ToString();
                    or1.Parameters.Add("ARAWERT2", OracleType.NVarChar).Value = dwData["ARAWERT2"].ToString();
                    or1.Parameters.Add("ARAKZPA2", OracleType.NVarChar).Value = dwData["ARAKZPA2"].ToString();
                    or1.Parameters.Add("ARAKZBP2", OracleType.NVarChar).Value = dwData["ARAKZBP2"].ToString();
                    or1.Parameters.Add("ARAME2", OracleType.NVarChar).Value = dwData["ARAME2"].ToString();
                    or1.Parameters.Add("ARBEMKZ2", OracleType.NVarChar).Value = dwData["ARBEMKZ2"].ToString();
                    or1.Parameters.Add("ARANFART3", OracleType.NVarChar).Value = dwData["ARANFART3"].ToString();
                    or1.Parameters.Add("ARAWERT3", OracleType.NVarChar).Value = dwData["ARAWERT3"].ToString();
                    or1.Parameters.Add("ARAKZPA3", OracleType.NVarChar).Value = dwData["ARAKZPA3"].ToString();
                    or1.Parameters.Add("ARAKZBP3", OracleType.NVarChar).Value = dwData["ARAKZBP3"].ToString();
                    or1.Parameters.Add("ARAME3", OracleType.NVarChar).Value = dwData["ARAME3"].ToString();
                    or1.Parameters.Add("ARBEMKZ3", OracleType.NVarChar).Value = dwData["ARBEMKZ3"].ToString();
                    or1.Parameters.Add("ARANFART4", OracleType.NVarChar).Value = dwData["ARANFART4"].ToString();
                    or1.Parameters.Add("ARAWERT4", OracleType.NVarChar).Value = dwData["ARAWERT4"].ToString();
                    or1.Parameters.Add("ARAKZPA4", OracleType.NVarChar).Value = dwData["ARAKZPA4"].ToString();
                    or1.Parameters.Add("ARAKZBP4", OracleType.NVarChar).Value = dwData["ARAKZBP4"].ToString();
                    or1.Parameters.Add("ARAME4", OracleType.NVarChar).Value = dwData["ARAME4"].ToString();
                    or1.Parameters.Add("ARBEMKZ4", OracleType.NVarChar).Value = dwData["ARBEMKZ4"].ToString();
                    or1.Parameters.Add("ARANFART5", OracleType.NVarChar).Value = dwData["ARANFART5"].ToString();
                    or1.Parameters.Add("ARAWERT5", OracleType.NVarChar).Value = dwData["ARAWERT5"].ToString();
                    or1.Parameters.Add("ARAKZPA5", OracleType.NVarChar).Value = dwData["ARAKZPA5"].ToString();
                    or1.Parameters.Add("ARAKZBP5", OracleType.NVarChar).Value = dwData["ARAKZBP5"].ToString();
                    or1.Parameters.Add("ARAME5", OracleType.NVarChar).Value = dwData["ARAME5"].ToString();
                    or1.Parameters.Add("ARBEMKZ5", OracleType.NVarChar).Value = dwData["ARBEMKZ5"].ToString();
                    or1.Parameters.Add("ARANFART6", OracleType.NVarChar).Value = dwData["ARANFART6"].ToString();
                    or1.Parameters.Add("ARAWERT6", OracleType.NVarChar).Value = dwData["ARAWERT6"].ToString();
                    or1.Parameters.Add("ARAKZPA6", OracleType.NVarChar).Value = dwData["ARAKZPA6"].ToString();
                    or1.Parameters.Add("ARAKZBP6", OracleType.NVarChar).Value = dwData["ARAKZBP6"].ToString();
                    or1.Parameters.Add("ARAME6", OracleType.NVarChar).Value = dwData["ARAME6"].ToString();
                    or1.Parameters.Add("ARBEMKZ6", OracleType.NVarChar).Value = dwData["ARBEMKZ6"].ToString();
                    or1.Parameters.Add("ARANFART7", OracleType.NVarChar).Value = dwData["ARANFART7"].ToString();
                    or1.Parameters.Add("ARAWERT7", OracleType.NVarChar).Value = dwData["ARAWERT7"].ToString();
                    or1.Parameters.Add("ARAKZPA7", OracleType.NVarChar).Value = dwData["ARAKZPA7"].ToString();
                    or1.Parameters.Add("ARAKZBP7", OracleType.NVarChar).Value = dwData["ARAKZBP7"].ToString();
                    or1.Parameters.Add("ARAME7", OracleType.NVarChar).Value = dwData["ARAME7"].ToString();
                    or1.Parameters.Add("ARBEMKZ7", OracleType.NVarChar).Value = dwData["ARBEMKZ7"].ToString();
                    or1.Parameters.Add("ARANFART8", OracleType.NVarChar).Value = dwData["ARANFART8"].ToString();
                    or1.Parameters.Add("ARAWERT8", OracleType.NVarChar).Value = dwData["ARAWERT8"].ToString();
                    or1.Parameters.Add("ARAKZPA8", OracleType.NVarChar).Value = dwData["ARAKZPA8"].ToString();
                    or1.Parameters.Add("ARAKZBP8", OracleType.NVarChar).Value = dwData["ARAKZBP8"].ToString();
                    or1.Parameters.Add("ARAME8", OracleType.NVarChar).Value = dwData["ARAME8"].ToString();
                    or1.Parameters.Add("ARBEMKZ8", OracleType.NVarChar).Value = dwData["ARBEMKZ8"].ToString();
                    or1.Parameters.Add("ARANFART9", OracleType.NVarChar).Value = dwData["ARANFART9"].ToString();
                    or1.Parameters.Add("ARAWERT9", OracleType.NVarChar).Value = dwData["ARAWERT9"].ToString();
                    or1.Parameters.Add("ARAKZPA9", OracleType.NVarChar).Value = dwData["ARAKZPA9"].ToString();
                    or1.Parameters.Add("ARAKZBP9", OracleType.NVarChar).Value = dwData["ARAKZBP9"].ToString();
                    or1.Parameters.Add("ARAME9", OracleType.NVarChar).Value = dwData["ARAME9"].ToString();
                    or1.Parameters.Add("ARBEMKZ9", OracleType.NVarChar).Value = dwData["ARBEMKZ9"].ToString();
                    or1.Parameters.Add("ARANFART10", OracleType.NVarChar).Value = dwData["ARANFART10"].ToString();
                    or1.Parameters.Add("ARAWERT10", OracleType.NVarChar).Value = dwData["ARAWERT10"].ToString();
                    or1.Parameters.Add("ARAKZPA10", OracleType.NVarChar).Value = dwData["ARAKZPA10"].ToString();
                    or1.Parameters.Add("ARAKZBP10", OracleType.NVarChar).Value = dwData["ARAKZBP10"].ToString();
                    or1.Parameters.Add("ARAME10", OracleType.NVarChar).Value = dwData["ARAME10"].ToString();
                    or1.Parameters.Add("ARBEMKZ10", OracleType.NVarChar).Value = dwData["ARBEMKZ10"].ToString();
                    or1.Parameters.Add("ARVALDAT", OracleType.NVarChar).Value = dwData["ARVALDAT"].ToString();
                    or1.Parameters.Add("ARZAHLB", OracleType.NVarChar).Value = dwData["ARZAHLB"].ToString();
                    or1.Parameters.Add("ARPAMABR", OracleType.NVarChar).Value = dwData["ARPAMABR"].ToString();
                    or1.Parameters.Add("ARAUFWRT", OracleType.NVarChar).Value = dwData["ARAUFWRT"].ToString();
                    or1.Parameters.Add("ARBERBAS", OracleType.NVarChar).Value = dwData["ARBERBAS"].ToString();
                    or1.Parameters.Add("ARFKNVS", OracleType.NVarChar).Value = dwData["ARFKNVS"].ToString();
                    or1.Parameters.Add("ARFKSPTD", OracleType.NVarChar).Value = dwData["ARFKSPTD"].ToString();
                    or1.Parameters.Add("ARFKSPRD", OracleType.NVarChar).Value = dwData["ARFKSPRD"].ToString();
                    or1.Parameters.Add("ARKSTTKZ", OracleType.NVarChar).Value = dwData["ARKSTTKZ"].ToString();
                    or1.Parameters.Add("ARMINMGE", OracleType.NVarChar).Value = dwData["ARMINMGE"].ToString();
                    or1.Parameters.Add("ARMRKMP", OracleType.NVarChar).Value = dwData["ARMRKMP"].ToString();
                    or1.Parameters.Add("ARMWERTP", OracleType.NVarChar).Value = dwData["ARMWERTP"].ToString();
                    or1.Parameters.Add("ARRENR", OracleType.NVarChar).Value = dwData["ARRENR"].ToString();
                    or1.Parameters.Add("ARREPOS", OracleType.NVarChar).Value = dwData["ARREPOS"].ToString();
                    or1.Parameters.Add("ARRPREIS", OracleType.NVarChar).Value = dwData["ARRPREIS"].ToString();
                    or1.Parameters.Add("ARDRZUSCHL", OracleType.NVarChar).Value = dwData["ARDRZUSCHL"].ToString();
                    or1.Parameters.Add("ARBERZUSATZ", OracleType.NVarChar).Value = dwData["ARBERZUSATZ"].ToString();
                    or1.Parameters.Add("ARFFAKKZ", OracleType.NVarChar).Value = dwData["ARFFAKKZ"].ToString();
                    or1.Parameters.Add("ARWAEHRSL", OracleType.NVarChar).Value = dwData["ARWAEHRSL"].ToString();
                    or1.Parameters.Add("ARNIXVV", OracleType.NVarChar).Value = dwData["ARNIXVV"].ToString();
                    or1.Parameters.Add("ARABRWERT", OracleType.NVarChar).Value = dwData["ARABRWERT"].ToString();
                    or1.Parameters.Add("ARABRFAE", OracleType.NVarChar).Value = dwData["ARABRFAE"].ToString();
                    or1.Parameters.Add("ARKUNDNR", OracleType.NVarChar).Value = dwData["ARKUNDNR"].ToString();
                    or1.Parameters.Add("ARLIEFNR", OracleType.NVarChar).Value = dwData["ARLIEFNR"].ToString();
                    or1.Parameters.Add("ARFILLER", OracleType.NVarChar).Value = dwData["ARFILLER"].ToString();
                    or1.Parameters.Add("ARAENDBEN", OracleType.NVarChar).Value = dwData["ARAENDBEN"].ToString();
                    or1.Parameters.Add("ARAENDDAT", OracleType.NVarChar).Value = dwData["ARAENDDAT"].ToString();

                    #endregion
                    Connect2Proxy(or1);
                    break;
                case 2:
                    or1.CommandText = "UPDATE ABPR SET ARMANDANT=:ARMANDANT:,ARAUFKRS=:ARAUFKRS:,ARAUFLFD=:ARAUFLFD:,ARAUFPOS=:ARAUFPOS:,ARAFOLGE=:ARAFOLGE:,ARKZSPR=:ARKZSPR:,ARPNRKR=:ARPNRKR:,ARPLFDNR=:ARPLFDNR:,ARBESTKZ=:ARBESTKZ:,ARWPKZLT=:ARWPKZLT:,ARMENGE=:ARMENGE:,ARSTAFME=:ARSTAFME:,ARGRUPPE=:ARGRUPPE:,ARWERT=:ARWERT:,ARMMOD1=:ARMMOD1:,ARMRKM1=:ARMRKM1:,ARMWERT1=:ARMWERT1:,ARMKZPA1=:ARMKZPA1:,ARMME1=:ARMME1:,ARMMOD2=:ARMMOD2:,ARMRKM2=:ARMRKM2:,ARMWERT2=:ARMWERT2:,ARMKZPA2=:ARMKZPA2:,ARMME2=:ARMME2:,ARMMOD3=:ARMMOD3:,ARMRKM3=:ARMRKM3:,ARMWERT3=:ARMWERT3:,ARMKZPA3=:ARMKZPA3:,ARMME3=:ARMME3:,ARMMOD4=:ARMMOD4:,ARMRKM4=:ARMRKM4:,ARMWERT4=:ARMWERT4:,ARMKZPA4=:ARMKZPA4:,ARMME4=:ARMME4:,ARMMOD5=:ARMMOD5:,ARMRKM5=:ARMRKM5:,ARMWERT5=:ARMWERT5:,ARMKZPA5=:ARMKZPA5:,ARMME5=:ARMME5:,ARMMOD6=:ARMMOD6:,ARMRKM6=:ARMRKM6:,ARMWERT6=:ARMWERT6:,ARMKZPA6=:ARMKZPA6:,ARMME6=:ARMME6:,ARMMOD7=:ARMMOD7:,ARMRKM7=:ARMRKM7:,ARMWERT7=:ARMWERT7:,ARMKZPA7=:ARMKZPA7:,ARMME7=:ARMME7:,ARMMOD8=:ARMMOD8:,ARMRKM8=:ARMRKM8:,ARMWERT8=:ARMWERT8:,ARMKZPA8=:ARMKZPA8:,ARMME8=:ARMME8:,ARMMOD9=:ARMMOD9:,ARMRKM9=:ARMRKM9:,ARMWERT9=:ARMWERT9:,ARMKZPA9=:ARMKZPA9:,ARMME9=:ARMME9:,ARMMOD10=:ARMMOD10:,ARMRKM10=:ARMRKM10:,ARMWERT10=:ARMWERT10:,ARMKZPA10=:ARMKZPA10:,ARMME10=:ARMME10:,ARAMOD1=:ARAMOD1:,ARANFART1=:ARANFART1:,ARAWERT1=:ARAWERT1:,ARAKZPA1=:ARAKZPA1:,ARAKZBP1=:ARAKZBP1:,ARAME1=:ARAME1:,ARBEMKZ1=:ARBEMKZ1:,ARAMOD2=:ARAMOD2:,ARANFART2=:ARANFART2:,ARAWERT2=:ARAWERT2:,ARAKZPA2=:ARAKZPA2:,ARAKZBP2=:ARAKZBP2:,ARAME2=:ARAME2:,ARBEMKZ2=:ARBEMKZ2:,ARAMOD3=:ARAMOD3:,ARANFART3=:ARANFART3:,ARAWERT3=:ARAWERT3:,ARAKZPA3=:ARAKZPA3:,ARAKZBP3=:ARAKZBP3:,ARAME3=:ARAME3:,ARBEMKZ3=:ARBEMKZ3:,ARAMOD4=:ARAMOD4:,ARANFART4=:ARANFART4:,ARAWERT4=:ARAWERT4:,ARAKZPA4=:ARAKZPA4:,ARAKZBP4=:ARAKZBP4:,ARAME4=:ARAME4:,ARBEMKZ4=:ARBEMKZ4:,ARAMOD5=:ARAMOD5:,ARANFART5=:ARANFART5:,ARAWERT5=:ARAWERT5:,ARAKZPA5=:ARAKZPA5:,ARAKZBP5=:ARAKZBP5:,ARAME5=:ARAME5:,ARBEMKZ5=:ARBEMKZ5:,ARAMOD6=:ARAMOD6:,ARANFART6=:ARANFART6:,ARAWERT6=:ARAWERT6:,ARAKZPA6=:ARAKZPA6:,ARAKZBP6=:ARAKZBP6:,ARAME6=:ARAME6:,ARBEMKZ6=:ARBEMKZ6:,ARAMOD7=:ARAMOD7:,ARANFART7=:ARANFART7:,ARAWERT7=:ARAWERT7:,ARAKZPA7=:ARAKZPA7:,ARAKZBP7=:ARAKZBP7:,ARAME7=:ARAME7:,ARBEMKZ7=:ARBEMKZ7:,ARAMOD8=:ARAMOD8:,ARANFART8=:ARANFART8:,ARAWERT8=:ARAWERT8:,ARAKZPA8=:ARAKZPA8:,ARAKZBP8=:ARAKZBP8:,ARAME8=:ARAME8:,ARBEMKZ8=:ARBEMKZ8:,ARAMOD9=:ARAMOD9:,ARANFART9=:ARANFART9:,ARAWERT9=:ARAWERT9:,ARAKZPA9=:ARAKZPA9:,ARAKZBP9=:ARAKZBP9:,ARAME9=:ARAME9:,ARBEMKZ9=:ARBEMKZ9:,ARAMOD10=:ARAMOD10:,ARANFART10=:ARANFART10:,ARAWERT10=:ARAWERT10:,ARAKZPA10=:ARAKZPA10:,ARAKZBP10=:ARAKZBP10:,ARAME10=:ARAME10:,ARBEMKZ10=:ARBEMKZ10:,ARVALDAT=:ARVALDAT:,ARZAHLB=:ARZAHLB:,ARPAMABR=:ARPAMABR:,ARBERBAS=:ARBERBAS:,ARFKNVS=:ARFKNVS:,ARFKSPTD=:ARFKSPTD:,ARFKSPRD=:ARFKSPRD:,ARKSTTKZ=:ARKSTTKZ:,ARMINMGE=:ARMINMGE:,ARMRKMP=:ARMRKMP:,ARMWERTP=:ARMWERTP:,ARRENR=:ARRENR:,ARREPOS=:ARREPOS:,ARRPREIS=:ARRPREIS:,ARDRZUSCHL=:ARDRZUSCHL:,ARBERZUSATZ=:ARBERZUSATZ:,ARFFAKKZ=:ARFFAKKZ:,ARWAEHRSL=:ARWAEHRSL:,ARNIXVV=:ARNIXVV:,ARABRWERT=:ARABRWERT:,ARABRFAE=:ARABRFAE:,ARKUNDNR=:ARKUNDNR:,ARLIEFNR=:ARLIEFNR:,ARSTATUS=:ARSTATUS:,ARFILLER=:ARFILLER:,ARAENDBEN=:ARAENDBEN:,ARAENDDAT=:ARAENDDAT:"
                        + " WHERE  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
                case 3:
                    or1.CommandText = "UPDATE ABPR SET ARMANDANT=:ARMANDANT:,ARAUFKRS=:ARAUFKRS:,ARAUFLFD=:ARAUFLFD:,ARAUFPOS=:ARAUFPOS:,ARAFOLGE=:ARAFOLGE:,ARKZSPR=:ARKZSPR:,ARPNRKR=:ARPNRKR:,ARPLFDNR=:ARPLFDNR:,ARBESTKZ=:ARBESTKZ:,ARWPKZLT=:ARWPKZLT:,ARMENGE=:ARMENGE:,ARSTAFME=:ARSTAFME:,ARGRUPPE=:ARGRUPPE:,ARWERT=:ARWERT:,ARMRKM1=:ARMRKM1:,ARMWERT1=:ARMWERT1:,ARMKZPA1=:ARMKZPA1:,ARMME1=:ARMME1:,ARMRKM2=:ARMRKM2:,ARMWERT2=:ARMWERT2:,ARMKZPA2=:ARMKZPA2:,ARMME2=:ARMME2:,ARMRKM3=:ARMRKM3:,ARMWERT3=:ARMWERT3:,ARMKZPA3=:ARMKZPA3:,ARMME3=:ARMME3:,ARMRKM4=:ARMRKM4:,ARMWERT4=:ARMWERT4:,ARMKZPA4=:ARMKZPA4:,ARMME4=:ARMME4:,ARMRKM5=:ARMRKM5:,ARMWERT5=:ARMWERT5:,ARMKZPA5=:ARMKZPA5:,ARMME5=:ARMME5:,ARMRKM6=:ARMRKM6:,ARMWERT6=:ARMWERT6:,ARMKZPA6=:ARMKZPA6:,ARMME6=:ARMME6:,ARMRKM7=:ARMRKM7:,ARMWERT7=:ARMWERT7:,ARMKZPA7=:ARMKZPA7:,ARMME7=:ARMME7:,ARMRKM8=:ARMRKM8:,ARMWERT8=:ARMWERT8:,ARMKZPA8=:ARMKZPA8:,ARMME8=:ARMME8:,ARMRKM9=:ARMRKM9:,ARMWERT9=:ARMWERT9:,ARMKZPA9=:ARMKZPA9:,ARMME9=:ARMME9:,ARMRKM10=:ARMRKM10:,ARMWERT10=:ARMWERT10:,ARMKZPA10=:ARMKZPA10:,ARMME10=:ARMME10:,ARANFART1=:ARANFART1:,ARAWERT1=:ARAWERT1:,ARAKZPA1=:ARAKZPA1:,ARAKZBP1=:ARAKZBP1:,ARAME1=:ARAME1:,ARBEMKZ1=:ARBEMKZ1:,ARANFART2=:ARANFART2:,ARAWERT2=:ARAWERT2:,ARAKZPA2=:ARAKZPA2:,ARAKZBP2=:ARAKZBP2:,ARAME2=:ARAME2:,ARBEMKZ2=:ARBEMKZ2:,ARANFART3=:ARANFART3:,ARAWERT3=:ARAWERT3:,ARAKZPA3=:ARAKZPA3:,ARAKZBP3=:ARAKZBP3:,ARAME3=:ARAME3:,ARBEMKZ3=:ARBEMKZ3:,ARANFART4=:ARANFART4:,ARAWERT4=:ARAWERT4:,ARAKZPA4=:ARAKZPA4:,ARAKZBP4=:ARAKZBP4:,ARAME4=:ARAME4:,ARBEMKZ4=:ARBEMKZ4:,ARANFART5=:ARANFART5:,ARAWERT5=:ARAWERT5:,ARAKZPA5=:ARAKZPA5:,ARAKZBP5=:ARAKZBP5:,ARAME5=:ARAME5:,ARBEMKZ5=:ARBEMKZ5:,ARANFART6=:ARANFART6:,ARAWERT6=:ARAWERT6:,ARAKZPA6=:ARAKZPA6:,ARAKZBP6=:ARAKZBP6:,ARAME6=:ARAME6:,ARBEMKZ6=:ARBEMKZ6:,ARANFART7=:ARANFART7:,ARAWERT7=:ARAWERT7:,ARAKZPA7=:ARAKZPA7:,ARAKZBP7=:ARAKZBP7:,ARAME7=:ARAME7:,ARBEMKZ7=:ARBEMKZ7:,ARANFART8=:ARANFART8:,ARAWERT8=:ARAWERT8:,ARAKZPA8=:ARAKZPA8:,ARAKZBP8=:ARAKZBP8:,ARAME8=:ARAME8:,ARBEMKZ8=:ARBEMKZ8:,ARANFART9=:ARANFART9:,ARAWERT9=:ARAWERT9:,ARAKZPA9=:ARAKZPA9:,ARAKZBP9=:ARAKZBP9:,ARAME9=:ARAME9:,ARBEMKZ9=:ARBEMKZ9:,ARANFART10=:ARANFART10:,ARAWERT10=:ARAWERT10:,ARAKZPA10=:ARAKZPA10:,ARAKZBP10=:ARAKZBP10:,ARAME10=:ARAME10:,ARBEMKZ10=:ARBEMKZ10:,ARVALDAT=:ARVALDAT:,ARZAHLB=:ARZAHLB:,ARPAMABR=:ARPAMABR:,ARAUFWRT=:ARAUFWRT:,ARBERBAS=:ARBERBAS:,ARFKNVS=:ARFKNVS:,ARFKSPTD=:ARFKSPTD:,ARFKSPRD=:ARFKSPRD:,ARKSTTKZ=:ARKSTTKZ:,ARMINMGE=:ARMINMGE:,ARMRKMP=:ARMRKMP:,ARMWERTP=:ARMWERTP:,ARRENR=:ARRENR:,ARREPOS=:ARREPOS:,ARRPREIS=:ARRPREIS:,ARDRZUSCHL=:ARDRZUSCHL:,ARBERZUSATZ=:ARBERZUSATZ:,ARFFAKKZ=:ARFFAKKZ:,ARWAEHRSL=:ARWAEHRSL:,ARNIXVV=:ARNIXVV:,ARABRWERT=:ARABRWERT:,ARABRFAE=:ARABRFAE:,ARKUNDNR=:ARKUNDNR:,ARLIEFNR=:ARLIEFNR:,ARFILLER=:ARFILLER:,ARAENDBEN=:ARAENDBEN:,ARAENDDAT=:ARAENDDAT:"
                                    + " WHERE  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
            }
          
        }
        public void InsertABPR(DataRow dwData, string ITXDBVERSION = "50.24")
        { 
            or1 = OracleDB.CreateCommand();
            switch (app.company)
            {
                case "JLT":
                    or1.CommandText = "INSERT INTO ABPR(ARMANDANT, ARAUFKRS, ARAUFLFD, ARAUFPOS, ARAFOLGE, ARKZSPR, ARPNRKR, ARPLFDNR, ARBESTKZ, ARWPKZLT, ARMENGE, ARSTAFME, ARGRUPPE, ARWERT, ARMRKM1, ARMWERT1, ARMKZPA1, ARMME1, ARMRKM2, ARMWERT2, ARMKZPA2, ARMME2, ARMRKM3, ARMWERT3, ARMKZPA3, ARMME3, ARMRKM4, ARMWERT4, ARMKZPA4, ARMME4, ARMRKM5, ARMWERT5, ARMKZPA5, ARMME5, ARMRKM6, ARMWERT6, ARMKZPA6, ARMME6, ARMRKM7, ARMWERT7, ARMKZPA7, ARMME7, ARMRKM8, ARMWERT8, ARMKZPA8, ARMME8, ARMRKM9, ARMWERT9, ARMKZPA9, ARMME9, ARMRKM10, ARMWERT10, ARMKZPA10, ARMME10, ARANFART1, ARAWERT1, ARAKZPA1, ARAKZBP1, ARAME1, ARBEMKZ1, ARANFART2, ARAWERT2, ARAKZPA2, ARAKZBP2, ARAME2, ARBEMKZ2, ARANFART3, ARAWERT3, ARAKZPA3, ARAKZBP3, ARAME3, ARBEMKZ3, ARANFART4, ARAWERT4, ARAKZPA4, ARAKZBP4, ARAME4, ARBEMKZ4, ARANFART5, ARAWERT5, ARAKZPA5, ARAKZBP5, ARAME5, ARBEMKZ5, ARANFART6, ARAWERT6, ARAKZPA6, ARAKZBP6, ARAME6, ARBEMKZ6, ARANFART7, ARAWERT7, ARAKZPA7, ARAKZBP7, ARAME7, ARBEMKZ7, ARANFART8, ARAWERT8, ARAKZPA8, ARAKZBP8, ARAME8, ARBEMKZ8, ARANFART9, ARAWERT9, ARAKZPA9, ARAKZBP9, ARAME9, ARBEMKZ9, ARANFART10, ARAWERT10, ARAKZPA10, ARAKZBP10, ARAME10, ARBEMKZ10, ARVALDAT, ARZAHLB, ARPAMABR, ARAUFWRT, ARBERBAS, ARFKNVS, ARFKSPTD, ARFKSPRD, ARKSTTKZ, ARMINMGE, ARMRKMP, ARMWERTP, ARRENR, ARREPOS, ARRPREIS, ARDRZUSCHL, ARBERZUSATZ, ARFFAKKZ, ARWAEHRSL, ARNIXVV, ARABRWERT, ARABRFAE, ARKUNDNR, ARLIEFNR, ARFILLER, ARAENDBEN, ARAENDDAT)"
                   + "VALUES (:ARMANDANT:, :ARAUFKRS:, :ARAUFLFD:, :ARAUFPOS:, '000', 'N', '  ', '000000', ' ', ' ', 0, ' ', ' ', 0, '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', '    ', 0, ' ', ' ', ' ', ' ', 0, '   ', ' ', '00000000000', ' ', ' ', 0, 0, 'J', 0, '    ', 0, '00000000', '000', 0, ' ', ' ', ' ', '   ', ' ', 0, ' ', '00000000', '        ', '50                                            ', '        ', 0)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
                case "FLT":
                    or1.CommandText = "INSERT INTO ABPR ( ARMANDANT,ARAUFKRS,ARAUFLFD,ARAUFPOS,ARAFOLGE,ARKZSPR,ARPNRKR,ARPLFDNR,ARBESTKZ,ARWPKZLT,ARMENGE,ARSTAFME,ARGRUPPE,ARWERT,ARMMOD1,ARMRKM1,ARMWERT1,ARMKZPA1,ARMME1,ARMMOD2,ARMRKM2,ARMWERT2,ARMKZPA2,ARMME2,ARMMOD3,ARMRKM3,ARMWERT3,ARMKZPA3,ARMME3,ARMMOD4,ARMRKM4,ARMWERT4,ARMKZPA4,ARMME4,ARMMOD5,ARMRKM5,ARMWERT5,ARMKZPA5,ARMME5,ARMMOD6,ARMRKM6,ARMWERT6,ARMKZPA6,ARMME6,ARMMOD7,ARMRKM7,ARMWERT7,ARMKZPA7,ARMME7,ARMMOD8,ARMRKM8,ARMWERT8,ARMKZPA8,ARMME8,ARMMOD9,ARMRKM9,ARMWERT9,ARMKZPA9,ARMME9,ARMMOD10,ARMRKM10,ARMWERT10,ARMKZPA10,ARMME10,ARAMOD1,ARANFART1,ARAWERT1,ARAKZPA1,ARAKZBP1,ARAME1,ARBEMKZ1,ARAMOD2,ARANFART2,ARAWERT2,ARAKZPA2,ARAKZBP2,ARAME2,ARBEMKZ2,ARAMOD3,ARANFART3,ARAWERT3,ARAKZPA3,ARAKZBP3,ARAME3,ARBEMKZ3,ARAMOD4,ARANFART4,ARAWERT4,ARAKZPA4,ARAKZBP4,ARAME4,ARBEMKZ4,ARAMOD5,ARANFART5,ARAWERT5,ARAKZPA5,ARAKZBP5,ARAME5,ARBEMKZ5,ARAMOD6,ARANFART6,ARAWERT6,ARAKZPA6,ARAKZBP6,ARAME6,ARBEMKZ6,ARAMOD7,ARANFART7,ARAWERT7,ARAKZPA7,ARAKZBP7,ARAME7,ARBEMKZ7,ARAMOD8,ARANFART8,ARAWERT8,ARAKZPA8,ARAKZBP8,ARAME8,ARBEMKZ8,ARAMOD9,ARANFART9,ARAWERT9,ARAKZPA9,ARAKZBP9,ARAME9,ARBEMKZ9,ARAMOD10,ARANFART10,ARAWERT10,ARAKZPA10,ARAKZBP10,ARAME10,ARBEMKZ10,ARVALDAT,ARZAHLB,ARPAMABR,ARBERBAS,ARFKNVS,ARFKSPTD,ARFKSPRD,ARKSTTKZ,ARMINMGE,ARMRKMP,ARMWERTP,ARRENR,ARREPOS,ARRPREIS,ARDRZUSCHL,ARBERZUSATZ,ARFFAKKZ,ARWAEHRSL,ARNIXVV,ARABRWERT,ARABRFAE,ARKUNDNR,ARLIEFNR,ARSTATUS,ARFILLER,ARAENDBEN,ARAENDDAT)"
                    + " VALUES (:ARMANDANT:,:ARAUFKRS:,:ARAUFLFD:,:ARAUFPOS:,:ARAFOLGE:,:ARKZSPR:,:ARPNRKR:,:ARPLFDNR:,:ARBESTKZ:,:ARWPKZLT:,:ARMENGE:,:ARSTAFME:,:ARGRUPPE:,:ARWERT:,:ARMMOD1:,:ARMRKM1:,:ARMWERT1:,:ARMKZPA1:,:ARMME1:,:ARMMOD2:,:ARMRKM2:,:ARMWERT2:,:ARMKZPA2:,:ARMME2:,:ARMMOD3:,:ARMRKM3:,:ARMWERT3:,:ARMKZPA3:,:ARMME3:,:ARMMOD4:,:ARMRKM4:,:ARMWERT4:,:ARMKZPA4:,:ARMME4:,:ARMMOD5:,:ARMRKM5:,:ARMWERT5:,:ARMKZPA5:,:ARMME5:,:ARMMOD6:,:ARMRKM6:,:ARMWERT6:,:ARMKZPA6:,:ARMME6:,:ARMMOD7:,:ARMRKM7:,:ARMWERT7:,:ARMKZPA7:,:ARMME7:,:ARMMOD8:,:ARMRKM8:,:ARMWERT8:,:ARMKZPA8:,:ARMME8:,:ARMMOD9:,:ARMRKM9:,:ARMWERT9:,:ARMKZPA9:,:ARMME9:,:ARMMOD10:,:ARMRKM10:,:ARMWERT10:,:ARMKZPA10:,:ARMME10:,:ARAMOD1:,:ARANFART1:,:ARAWERT1:,:ARAKZPA1:,:ARAKZBP1:,:ARAME1:,:ARBEMKZ1:,:ARAMOD2:,:ARANFART2:,:ARAWERT2:,:ARAKZPA2:,:ARAKZBP2:,:ARAME2:,:ARBEMKZ2:,:ARAMOD3:,:ARANFART3:,:ARAWERT3:,:ARAKZPA3:,:ARAKZBP3:,:ARAME3:,:ARBEMKZ3:,:ARAMOD4:,:ARANFART4:,:ARAWERT4:,:ARAKZPA4:,:ARAKZBP4:,:ARAME4:,:ARBEMKZ4:,:ARAMOD5:,:ARANFART5:,:ARAWERT5:,:ARAKZPA5:,:ARAKZBP5:,:ARAME5:,:ARBEMKZ5:,:ARAMOD6:,:ARANFART6:,:ARAWERT6:,:ARAKZPA6:,:ARAKZBP6:,:ARAME6:,:ARBEMKZ6:,:ARAMOD7:,:ARANFART7:,:ARAWERT7:,:ARAKZPA7:,:ARAKZBP7:,:ARAME7:,:ARBEMKZ7:,:ARAMOD8:,:ARANFART8:,:ARAWERT8:,:ARAKZPA8:,:ARAKZBP8:,:ARAME8:,:ARBEMKZ8:,:ARAMOD9:,:ARANFART9:,:ARAWERT9:,:ARAKZPA9:,:ARAKZBP9:,:ARAME9:,:ARBEMKZ9:,:ARAMOD10:,:ARANFART10:,:ARAWERT10:,:ARAKZPA10:,:ARAKZBP10:,:ARAME10:,:ARBEMKZ10:,:ARVALDAT:,:ARZAHLB:,:ARPAMABR:,:ARBERBAS:,:ARFKNVS:,:ARFKSPTD:,:ARFKSPRD:,:ARKSTTKZ:,:ARMINMGE:,:ARMRKMP:,:ARMWERTP:,:ARRENR:,:ARREPOS:,:ARRPREIS:,:ARDRZUSCHL:,:ARBERZUSATZ:,:ARFFAKKZ:,:ARWAEHRSL:,:ARNIXVV:,:ARABRWERT:,:ARABRFAE:,:ARKUNDNR:,:ARLIEFNR:,:ARSTATUS:,:ARFILLER:,:ARAENDBEN:,:ARAENDDAT:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
                default:
                case "YGR":
                    or1.CommandText = "INSERT INTO ABPR ( ARMANDANT,ARAUFKRS,ARAUFLFD,ARAUFPOS,ARAFOLGE,ARKZSPR,ARPNRKR,ARPLFDNR,ARBESTKZ,ARWPKZLT,ARMENGE,ARSTAFME,ARGRUPPE,ARWERT,ARMRKM1,ARMWERT1,ARMKZPA1,ARMME1,ARMRKM2,ARMWERT2,ARMKZPA2,ARMME2,ARMRKM3,ARMWERT3,ARMKZPA3,ARMME3,ARMRKM4,ARMWERT4,ARMKZPA4,ARMME4,ARMRKM5,ARMWERT5,ARMKZPA5,ARMME5,ARMRKM6,ARMWERT6,ARMKZPA6,ARMME6,ARMRKM7,ARMWERT7,ARMKZPA7,ARMME7,ARMRKM8,ARMWERT8,ARMKZPA8,ARMME8,ARMRKM9,ARMWERT9,ARMKZPA9,ARMME9,ARMRKM10,ARMWERT10,ARMKZPA10,ARMME10,ARANFART1,ARAWERT1,ARAKZPA1,ARAKZBP1,ARAME1,ARBEMKZ1,ARANFART2,ARAWERT2,ARAKZPA2,ARAKZBP2,ARAME2,ARBEMKZ2,ARANFART3,ARAWERT3,ARAKZPA3,ARAKZBP3,ARAME3,ARBEMKZ3,ARANFART4,ARAWERT4,ARAKZPA4,ARAKZBP4,ARAME4,ARBEMKZ4,ARANFART5,ARAWERT5,ARAKZPA5,ARAKZBP5,ARAME5,ARBEMKZ5,ARANFART6,ARAWERT6,ARAKZPA6,ARAKZBP6,ARAME6,ARBEMKZ6,ARANFART7,ARAWERT7,ARAKZPA7,ARAKZBP7,ARAME7,ARBEMKZ7,ARANFART8,ARAWERT8,ARAKZPA8,ARAKZBP8,ARAME8,ARBEMKZ8,ARANFART9,ARAWERT9,ARAKZPA9,ARAKZBP9,ARAME9,ARBEMKZ9,ARANFART10,ARAWERT10,ARAKZPA10,ARAKZBP10,ARAME10,ARBEMKZ10,ARVALDAT,ARZAHLB,ARPAMABR,ARAUFWRT,ARBERBAS,ARFKNVS,ARFKSPTD,ARFKSPRD,ARKSTTKZ,ARMINMGE,ARMRKMP,ARMWERTP,ARRENR,ARREPOS,ARRPREIS,ARDRZUSCHL,ARBERZUSATZ,ARFFAKKZ,ARWAEHRSL,ARNIXVV,ARABRWERT,ARABRFAE,ARKUNDNR,ARLIEFNR,ARFILLER,ARAENDBEN,ARAENDDAT)"
                    + " VALUES (:ARMANDANT:,:ARAUFKRS:,:ARAUFLFD:,:ARAUFPOS:,:ARAFOLGE:,:ARKZSPR:,:ARPNRKR:,:ARPLFDNR:,:ARBESTKZ:,:ARWPKZLT:,:ARMENGE:,:ARSTAFME:,:ARGRUPPE:,:ARWERT:,:ARMRKM1:,:ARMWERT1:,:ARMKZPA1:,:ARMME1:,:ARMRKM2:,:ARMWERT2:,:ARMKZPA2:,:ARMME2:,:ARMRKM3:,:ARMWERT3:,:ARMKZPA3:,:ARMME3:,:ARMRKM4:,:ARMWERT4:,:ARMKZPA4:,:ARMME4:,:ARMRKM5:,:ARMWERT5:,:ARMKZPA5:,:ARMME5:,:ARMRKM6:,:ARMWERT6:,:ARMKZPA6:,:ARMME6:,:ARMRKM7:,:ARMWERT7:,:ARMKZPA7:,:ARMME7:,:ARMRKM8:,:ARMWERT8:,:ARMKZPA8:,:ARMME8:,:ARMRKM9:,:ARMWERT9:,:ARMKZPA9:,:ARMME9:,:ARMRKM10:,:ARMWERT10:,:ARMKZPA10:,:ARMME10:,:ARANFART1:,:ARAWERT1:,:ARAKZPA1:,:ARAKZBP1:,:ARAME1:,:ARBEMKZ1:,:ARANFART2:,:ARAWERT2:,:ARAKZPA2:,:ARAKZBP2:,:ARAME2:,:ARBEMKZ2:,:ARANFART3:,:ARAWERT3:,:ARAKZPA3:,:ARAKZBP3:,:ARAME3:,:ARBEMKZ3:,:ARANFART4:,:ARAWERT4:,:ARAKZPA4:,:ARAKZBP4:,:ARAME4:,:ARBEMKZ4:,:ARANFART5:,:ARAWERT5:,:ARAKZPA5:,:ARAKZBP5:,:ARAME5:,:ARBEMKZ5:,:ARANFART6:,:ARAWERT6:,:ARAKZPA6:,:ARAKZBP6:,:ARAME6:,:ARBEMKZ6:,:ARANFART7:,:ARAWERT7:,:ARAKZPA7:,:ARAKZBP7:,:ARAME7:,:ARBEMKZ7:,:ARANFART8:,:ARAWERT8:,:ARAKZPA8:,:ARAKZBP8:,:ARAME8:,:ARBEMKZ8:,:ARANFART9:,:ARAWERT9:,:ARAKZPA9:,:ARAKZBP9:,:ARAME9:,:ARBEMKZ9:,:ARANFART10:,:ARAWERT10:,:ARAKZPA10:,:ARAKZBP10:,:ARAME10:,:ARBEMKZ10:,:ARVALDAT:,:ARZAHLB:,:ARPAMABR:,:ARAUFWRT:,:ARBERBAS:,:ARFKNVS:,:ARFKSPTD:,:ARFKSPRD:,:ARKSTTKZ:,:ARMINMGE:,:ARMRKMP:,:ARMWERTP:,:ARRENR:,:ARREPOS:,:ARRPREIS:,:ARDRZUSCHL:,:ARBERZUSATZ:,:ARFFAKKZ:,:ARWAEHRSL:,:ARNIXVV:,:ARABRWERT:,:ARABRFAE:,:ARKUNDNR:,:ARLIEFNR:,:ARFILLER:,:ARAENDBEN:,:ARAENDDAT:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
            }
            
        }
        public void DeleteABPR(string client, string krs, string lfd, string pos, int option = 1)
        {
           
            or1 = OracleDB.CreateCommand();

            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ABPR WHERE  "
                    + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD: AND ARAUFPOS=:ARAUFPOS:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
                case 2:
                    or1.CommandText = "DELETE FROM ABPR WHERE  "
                    + "  ARMANDANT=:ARMANDANT: AND ARAUFKRS=:ARAUFKRS: AND ARAUFLFD=:ARAUFLFD:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    Connect2Proxy(or1);
                    break;
                default:
                    break;
            }
           
        }
    }
}
